%%{init: {'themeVariables': { 'fontSize': '12px'}}}%%
graph TD
    classDef path fill:#eee,stroke:#000,color:#000
    classDef plan fill:#fff,stroke-width:1px,color:#000
    classDef itemplan fill:#fff,stroke-width:2px,color:#000
    classDef unbatchedplan fill:#dff,stroke-width:1px,color:#000
    classDef sideeffectplan fill:#fcc,stroke-width:2px,color:#000
    classDef bucket fill:#f6f6f6,color:#000,stroke-width:2px,text-align:left

    subgraph "Buckets for queries/refs/posts-author-singular-ref"
    Bucket0("Bucket 0 (root)<br /><br />1: PgSelectInlineApply[28]<br />ᐳ: Access[9], Access[10], Object[11]<br />2: PgSelect[8]<br />ᐳ: Access[29]<br />3: Connection[12]<br />4: ConnectionItems[14]"):::bucket
    Bucket1("Bucket 1 (nullableBoundary)<br />Deps: 12, 14, 29<br /><br />ROOT Connectionᐸ8ᐳ[12]"):::bucket
    Bucket3("Bucket 3 (listItem)<br />Deps: 29<br /><br />ROOT __Item{3}ᐸ14ᐳ[17]"):::bucket
    Bucket4("Bucket 4 (nullableBoundary)<br />Deps: 29, 18<br /><br />ROOT PgSelectSingle{3}ᐸpostsᐳ[18]<br />1: <br />ᐳ: List[30], Lambda[31]<br />2: PgSelectRows[25]<br />ᐳ: First[24], PgSelectSingle[26]"):::bucket
    Bucket5("Bucket 5 (nullableBoundary)<br />Deps: 26<br /><br />ROOT PgSelectSingle{4}ᐸpeopleᐳ[26]"):::bucket
    end
    Bucket0 --> Bucket1
    Bucket1 --> Bucket3
    Bucket3 --> Bucket4
    Bucket4 --> Bucket5

    %% plan dependencies
    PgSelect8[["PgSelect[8∈0] ➊<br />ᐸpostsᐳ"]]:::plan
    Object11{{"Object[11∈0] ➊<br />ᐸ{pgSettings,withPgClient}ᐳ"}}:::plan
    PgSelectInlineApply28["PgSelectInlineApply[28∈0] ➊"]:::plan
    Object11 & PgSelectInlineApply28 --> PgSelect8
    Access9{{"Access[9∈0] ➊<br />ᐸ2.pgSettingsᐳ"}}:::plan
    Access10{{"Access[10∈0] ➊<br />ᐸ2.withPgClientᐳ"}}:::plan
    Access9 & Access10 --> Object11
    __Value2["__Value[2∈0] ➊<br />ᐸcontextᐳ"]:::plan
    __Value2 --> Access9
    __Value2 --> Access10
    Connection12[["Connection[12∈0] ➊<br />ᐸ8ᐳ"]]:::plan
    PgSelect8 --> Connection12
    ConnectionItems14[["ConnectionItems[14∈0] ➊"]]:::plan
    Connection12 --> ConnectionItems14
    Access29{{"Access[29∈0] ➊<br />ᐸ8.m.joinDetailsFor20ᐳ"}}:::plan
    PgSelect8 --> Access29
    __Item17[/"__Item[17∈3]<br />ᐸ14ᐳ"\]:::itemplan
    ConnectionItems14 ==> __Item17
    PgSelectSingle18{{"PgSelectSingle[18∈3]<br />ᐸpostsᐳ"}}:::plan
    __Item17 --> PgSelectSingle18
    List30{{"List[30∈4]<br />ᐸ29,18ᐳ"}}:::plan
    Access29 & PgSelectSingle18 --> List30
    First24{{"First[24∈4]"}}:::plan
    PgSelectRows25[["PgSelectRows[25∈4]"]]:::plan
    PgSelectRows25 --> First24
    Lambda31{{"Lambda[31∈4]<br />ᐸpgInlineViaJoinTransformᐳ"}}:::plan
    Lambda31 --> PgSelectRows25
    PgSelectSingle26{{"PgSelectSingle[26∈4]<br />ᐸpeopleᐳ"}}:::plan
    First24 --> PgSelectSingle26
    List30 --> Lambda31
    PgClassExpression27{{"PgClassExpression[27∈5]<br />ᐸ__people__.”name”ᐳ"}}:::plan
    PgSelectSingle26 --> PgClassExpression27

    %% define steps
    classDef bucket0 stroke:#696969
    class Bucket0,__Value2,PgSelect8,Access9,Access10,Object11,Connection12,ConnectionItems14,PgSelectInlineApply28,Access29 bucket0
    classDef bucket1 stroke:#00bfff
    class Bucket1 bucket1
    classDef bucket3 stroke:#ffa500
    class Bucket3,__Item17,PgSelectSingle18 bucket3
    classDef bucket4 stroke:#0000ff
    class Bucket4,First24,PgSelectRows25,PgSelectSingle26,List30,Lambda31 bucket4
    classDef bucket5 stroke:#7fff00
    class Bucket5,PgClassExpression27 bucket5

